Tabela PhDrugDDD

Definicja tabeli PhDrugDDD

Name

PhDrugDDD

Code

PhDrugDDD

Comment

tabela ze Zdefiniowanymi Dziennymi Dawkami (defined daily dose)


Lista kolumn tabeli PhDrugDDD

Name

Code

DrugDDDID

DrugDDDID

StockItemID

StockItemID

DailyUsageQuantity

DailyUsageQuantity

DailyUsageUnitID

DailyUsageUnitID

SummaryUsageQuantity

SummaryUsageQuantity

SummaryUsageUnitID

SummaryUsageUnitID

TimeOfUsageQuantity

TimeOfUsageQuantity

TimeOfUsageUnitID

TimeOfUsageUnitID

AgeQuantity

AgeQuantity

AgeUnitID

AgeUnitID

Weight

Weight

BodySurface

BodySurface

ItemNo

ItemNo


Kolumna DrugDDDID tabeli PhDrugDDD

Definicja kolumny DrugDDDID tabeli PhDrugDDD

Name

DrugDDDID

Code

DrugDDDID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz glówny


Kolumna StockItemID tabeli PhDrugDDD

Definicja kolumny StockItemID tabeli PhDrugDDD

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

id asortymentu


Kolumna DailyUsageQuantity tabeli PhDrugDDD

Definicja kolumny DailyUsageQuantity tabeli PhDrugDDD

Name

DailyUsageQuantity

Code

DailyUsageQuantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

dzienna dawka (ilosc)


Kolumna DailyUsageUnitID tabeli PhDrugDDD

Definicja kolumny DailyUsageUnitID tabeli PhDrugDDD

Name

DailyUsageUnitID

Code

DailyUsageUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

dzienna dawka (jednostka)


Kolumna SummaryUsageQuantity tabeli PhDrugDDD

Definicja kolumny SummaryUsageQuantity tabeli PhDrugDDD

Name

SummaryUsageQuantity

Code

SummaryUsageQuantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

sumaryczna dawka (ilosc)


Kolumna SummaryUsageUnitID tabeli PhDrugDDD

Definicja kolumny SummaryUsageUnitID tabeli PhDrugDDD

Name

SummaryUsageUnitID

Code

SummaryUsageUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

sumaryczna dawka (jednostka)


Kolumna TimeOfUsageQuantity tabeli PhDrugDDD

Definicja kolumny TimeOfUsageQuantity tabeli PhDrugDDD

Name

TimeOfUsageQuantity

Code

TimeOfUsageQuantity

Data Type

NUMBER(10)

Mandatory

No

Comment

maksymalny czas podawania (ilosc)


Kolumna TimeOfUsageUnitID tabeli PhDrugDDD

Definicja kolumny TimeOfUsageUnitID tabeli PhDrugDDD

Name

TimeOfUsageUnitID

Code

TimeOfUsageUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

maksymalny czas podawania (jednostka)


Kolumna AgeQuantity tabeli PhDrugDDD

Definicja kolumny AgeQuantity tabeli PhDrugDDD

Name

AgeQuantity

Code

AgeQuantity

Data Type

NUMBER(10)

Mandatory

No

Comment

wiek pacjenta


Kolumna AgeUnitID tabeli PhDrugDDD

Definicja kolumny AgeUnitID tabeli PhDrugDDD

Name

AgeUnitID

Code

AgeUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

wiek pacjenta (jednostka)


Kolumna Weight tabeli PhDrugDDD

Definicja kolumny Weight tabeli PhDrugDDD

Name

Weight

Code

Weight

Data Type

NUMBER(19,8)

Mandatory

No

Comment

waga pacjenta


Kolumna BodySurface tabeli PhDrugDDD

Definicja kolumny BodySurface tabeli PhDrugDDD

Name

BodySurface

Code

BodySurface

Data Type

NUMBER(19,8)

Mandatory

No

Comment

powierzchnia ciala


Kolumna ItemNo tabeli PhDrugDDD

Definicja kolumny ItemNo tabeli PhDrugDDD

Name

ItemNo

Code

ItemNo

Data Type

NUMBER(10)

Mandatory

No

Comment

Numer pozycji


Lista kluczy tabeli PhDrugDDD

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhDrugDDD

Definicja klucza Identifier_1 tabeli PhDrugDDD

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment